﻿CREATE TABLE [trUser].[tblUserDevices] (
    [IDUserDevice]      BIGINT         IDENTITY (1, 1) NOT NULL,
    [IDUser]            BIGINT         NOT NULL,
    [DeviceName]        NVARCHAR (50)  NULL,
    [DeviceType]        NVARCHAR (50)  NULL,
    [DeviceID]          NVARCHAR (50)  NULL,
    [DeviceUUID]        NVARCHAR (50)  NULL,
    [DeviceDescription] NVARCHAR (255) NULL,
    [DateCreated]       DATETIME       CONSTRAINT [DF_tblUserDevices_DateCreated] DEFAULT (getdate()) NOT NULL,
    [DateUpdated]       DATETIME       NULL,
    [DateInactive]      DATETIME       NULL,
    CONSTRAINT [PK_tblUserDevices] PRIMARY KEY CLUSTERED ([IDUserDevice] ASC)
);

